<?php
/**
 * The Template for displaying all single posts.
 *
 * @package WordPress
 * @subpackage Twenty_Ten
 * @since Twenty Ten 1.0
 */
if($_GET[flag]){
	comments_template( '', true );
}
if(!$_GET[flag]):
get_header(); ?>

		<div id="container">
			<div id="content" role="main">

<?php if ( have_posts() ) while ( have_posts() ) : the_post(); ?>

				<div id="nav-above" class="navigation">
					<div class="nav-previous"><?php previous_post_link( '%link', '<span class="meta-nav">' . _x( '&larr;', 'Previous post link', 'twentyten' ) . '</span> %title' ); ?></div>
					<div class="nav-next"><?php next_post_link( '%link', '%title <span class="meta-nav">' . _x( '&rarr;', 'Next post link', 'twentyten' ) . '</span>' ); ?></div>
				</div><!-- #nav-above -->

				<div id="post-<?php the_ID(); ?>" <?php post_class(); ?>>
					<h1 class="entry-title"><?php the_title(); ?></h1>

					<div class="entry-meta">
						<?php twentyten_posted_on(); ?>
					</div><!-- .entry-meta -->

					<div class="entry-content">
						<?php the_content(); ?>
						<?php wp_link_pages( array( 'before' => '<div class="page-link">' . __( 'Pages:', 'twentyten' ), 'after' => '</div>' ) ); ?>
					</div><!-- .entry-content -->

<?php if ( get_the_author_meta( 'description' ) ) : // If a user has filled out their description, show a bio on their entries  ?>
					<div id="entry-author-info">
						<div id="author-avatar">
							<?php echo get_avatar( get_the_author_meta( 'user_email' ), apply_filters( 'twentyten_author_bio_avatar_size', 60 ) ); ?>
						</div><!-- #author-avatar -->
						<div id="author-description">
							<h2><?php printf( esc_attr__( 'About %s', 'twentyten' ), get_the_author() ); ?></h2>
							<?php the_author_meta( 'description' ); ?>
							<div id="author-link">
								<a href="<?php echo get_author_posts_url( get_the_author_meta( 'ID' ) ); ?>">
									<?php printf( __( 'View all posts by %s <span class="meta-nav">&rarr;</span>', 'twentyten' ), get_the_author() ); ?>
								</a>
							</div><!-- #author-link	-->
						</div><!-- #author-description -->
					</div><!-- #entry-author-info -->
<?php endif; 
$vote=$_GET[vote];
function  get_post_score()
{
	 include (ABSPATH.'/wp-content/themes/twentyten/connect_sql.php');
     global $id;
     $str="SELECT `score` from wp_posts WHERE ID=$id";
     $result=mysql_query($str,$link);$result=mysql_fetch_array($result);
     return  $result[0];
          
}
if($vote==1||$vote==2)
      {
      	  $voteip=$_SERVER['REMOTE_ADDR'];
          include (ABSPATH.'/wp-content/themes/twentyten/connect_sql.php');
          global $id;
          $str="SELECT `user_id` from wp_usermeta WHERE meta_key='$voteip' and meta_value=$id";
          $result=mysql_query($str,$link);$result=mysql_fetch_array($result);
          if($result) echo "您已经投过票了！";
          else
          {
          	  $userid=get_current_user_id();
          	  $str="INSERT INTO wp_usermeta (`umeta_id`,`user_id`,`meta_key`,`meta_value`) values ('','$userid','$voteip','$id')";
          	  if(mysql_query($str,$link)&&$voteip)
          	  {
          	  	  $str="UPDATE wp_posts SET score=score+$vote WHERE ID=$id";
          	  	  mysql_query($str,$link);
          	  	  $str="SELECT `post_author` FROM wp_posts WHERE ID=$id";
          	  	  $result=mysql_query($str,$link);
          	  	  $result=mysql_fetch_array($result);
          	  	  $auid=$result['post_author'];
          	  	  $str="SELECT `lastscore` FROM wp_users WHERE ID='$auid'";
          	  	  $result=mysql_query($str,$link);
          	  	  $result=mysql_fetch_array($result);
          	  	  $lastscore=$result['lastscore'];
          	  	  $time=date("Y-m",strtotime("this month"));
          	  	  if($time!=$lastscore) $add=$vote;
          	  	  else $add="user_score+".$vote;
          	  	  $str="UPDATE wp_users SET user_score=$add,user_scoreall=user_scoreall+$vote,lastscore='$time' WHERE ID='$auid'";
          	  	  mysql_query($str,$link);
          	  	  echo "Voted";
          	  }
          	  else echo "Error";
          }
      }
?>
				<div><a href="?p=<?php the_ID();?>&vote=3">顶 </a> VS <a href="?p=<?php the_ID();?>&vote=1"> 踩 </a>&nbsp;&nbsp;人气：<?php echo get_post_score();?></div>
					<div class="entry-utility">
						<?php twentyten_posted_in(); ?>
						<?php edit_post_link( __( 'Edit', 'twentyten' ), '<span class="edit-link">', '</span>' ); ?>
					</div><!-- .entry-utility -->
				</div><!-- #post-## -->

				<div id="nav-below" class="navigation">
					<div class="nav-previous"><?php previous_post_link( '%link', '<span class="meta-nav">' . _x( '&larr;', 'Previous post link', 'twentyten' ) . '</span> %title' ); ?></div>
					<div class="nav-next"><?php next_post_link( '%link', '%title <span class="meta-nav">' . _x( '&rarr;', 'Next post link', 'twentyten' ) . '</span>' ); ?></div>
				</div><!-- #nav-below -->

				<?php comments_template( '', true ); ?>

<?php endwhile; // end of the loop. ?>

			</div><!-- #content -->
		</div><!-- #container -->

<?php get_sidebar(); ?>
<?php get_footer(); ?>
<?php endif;?>